Sort Employees by Department Name

Begin by selecting the existing report from the Argos Navigation pane, highlight the report (Example Banded Report) then click Edit Report within the Detail Pane which brings up the Edit Report dialog box.

Since employees are to be grouped by department, click the Sort tab and move Departments.dept_id and Employees.emp_id into the right hand window. Argos will now sort by department ID, then by employee ID within each department. Remember to check the “Override the main report query sort” check box, otherwise you will not be able to move any fields.

Edit Report dialog with department name and employee selected as the fields to sort by.

Click the Apply button, the General Tab, then the Design button. You will be brought back to the Band Report Editor.